INSERT INTO customer(id,name, street, nr, postcode, city, created) values(null, 'demo-Kunde1', 'Muster-Straße', 3, '99999', 'Buxtehude', NOW());
INSERT INTO customer(id,name, street, nr, postcode, city, created) values(null, 'demo-Kunde2', 'Muster-Straße', 3, '99999', 'Buxtehude', NOW());
INSERT INTO customer(id,name, street, nr, postcode, city, created) values(null, 'demo-Kunde3', 'Muster-Straße', 3, '99999', 'Buxtehude', NOW());
INSERT INTO customer(id,name, street, nr, postcode, city, created) values(null, 'demo-Kunde4', 'Muster-Straße', 3, '99999', 'Buxtehude', NOW());
INSERT INTO customer(id,name, street, nr, postcode, city, created) values(null, 'demo-Kunde5', 'Muster-Straße', 3, '99999', 'Buxtehude', NOW());
INSERT INTO customer(id,name, street, nr, postcode, city, created) values(null, 'demo-Kunde6', 'Muster-Straße', 3, '99999', 'Buxtehude', NOW());
INSERT INTO customer(id,name, street, nr, postcode, city, created) values(null, 'demo-Kunde7', 'Muster-Straße', 3, '99999', 'Buxtehude', NOW());
INSERT INTO customer(id,name, street, nr, postcode, city, created) values(null, 'demo-Kunde8', 'Muster-Straße', 3, '99999', 'Buxtehude', NOW());

INSERT INTO customer(id,name, street, nr, postcode, city, created, retired) values(null, 'Kunde im Ruhestand', 'Muster-Straße', 3, '99999', 'Buxtehude', '2020-03-11 14:30:17',  NOW());


INSERT INTO project(id, name, customer_id, created) values(null, 'demo-Projekt1', 1, NOW());
INSERT INTO project(id, name, customer_id, created) values(null, 'demo-Projekt2', 1, NOW());
INSERT INTO project(id, name, customer_id, created) values(null, 'demo-Projekt3', 1, NOW());
INSERT INTO project(id, name, customer_id, created) values(null, 'demo-Projekt4', 1, NOW());
INSERT INTO project(id, name, customer_id, created) values(null, 'demo-Projekt5', 1, NOW());

INSERT INTO project(id, name, customer_id, created) values(null, 'demo-Projekt6', 2, NOW());
INSERT INTO project(id, name, customer_id, created) values(null, 'demo-Projekt7', 2, NOW());
INSERT INTO project(id, name, customer_id, created) values(null, 'demo-Projekt8', 2, NOW());
INSERT INTO project(id, name, customer_id, created) values(null, 'demo-Projekt9', 2, NOW());
INSERT INTO project(id, name, customer_id, created) values(null, 'demo-Projekt10', 2, NOW());
INSERT INTO project(id, name, customer_id, created) values(null, 'demo-Projekt11', 2, NOW());

INSERT INTO project(id, name, customer_id, created, retired) values(null, 'Retired-Project', 2, '2020-03-11 14:30:17', NOW());

INSERT INTO task(id, name, project_id, created) values(null, 'demo-Task1', 1, NOW());
INSERT INTO task(id, name, project_id, created) values(null, 'demo-Task2', 1, NOW());
INSERT INTO task(id, name, project_id, created) values(null, 'demo-Task3', 2, NOW());
INSERT INTO task(id, name, project_id, created) values(null, 'demo-Task4', 3, NOW());



INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 14:30:17', '2020-03-11 14:42:17', 1, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 14:42:17', '2020-03-11 14:43:17', 1, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 14:43:17', '2020-03-11 14:44:17', 1, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 14:44:17', '2020-03-11 14:45:17', 1, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 14:45:17', '2020-03-11 14:46:17', 1, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 14:46:17', '2020-03-11 14:47:17', 1, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 14:47:17', '2020-03-11 14:48:17', 1, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 14:48:17', '2020-03-11 14:49:17', 1, 1, '42 durch 0 teilen', null);

INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 14:49:17', '2020-03-11 14:50:17', 2, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 14:50:17', '2020-03-11 14:51:17', 2, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 14:51:17', '2020-03-11 14:52:17', 2, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 14:52:17', '2020-03-11 14:53:17', 2, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 14:53:17', '2020-03-11 14:54:17', 2, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 14:54:17', '2020-03-11 14:55:17', 2, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 14:55:17', '2020-03-11 14:56:17', 2, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 14:56:17', '2020-03-11 14:57:17', 2, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 14:57:17', '2020-03-11 14:58:17', 2, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 14:58:17', '2020-03-11 14:59:17', 2, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 14:59:17', '2020-03-11 15:00:17', 2, 1, '42 durch 0 teilen', null);

INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 15:00:17', '2020-03-11 15:01:17', 3, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 15:01:17', '2020-03-11 15:02:17', 3, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 15:02:17', '2020-03-11 15:03:17', 3, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 15:03:17', '2020-03-11 15:04:17', 3, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 15:04:17', '2020-03-11 15:05:17', 3, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 15:05:17', '2020-03-11 15:06:17', 3, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 15:06:17', '2020-03-11 15:07:17', 3, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 15:07:17', '2020-03-11 15:08:17', 3, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 15:08:17', '2020-03-11 15:09:17', 3, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 15:09:17', '2020-03-11 15:10:17', 3, 1, '42 durch 0 teilen', null);

INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 15:10:17', '2020-03-11 15:11:17', 4, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 15:11:17', '2020-03-11 15:12:17', 4, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 15:12:17', '2020-03-11 15:13:17', 4, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 15:13:17', '2020-03-11 15:14:17', 4, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 15:14:17', '2020-03-11 15:15:17', 4, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 15:15:17', '2020-03-11 15:16:17', 4, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 15:16:17', '2020-03-11 15:17:17', 4, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 15:17:17', '2020-03-11 15:18:17', 4, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 15:18:17', '2020-03-11 15:19:17', 4, 1, '42 durch 0 teilen', null);
INSERT INTO time(id, start, stop, task_id, user_id, text, billdate) values(null,'2020-03-11 15:19:17', '2020-03-11 16:20:17', 4, 1, '42 durch 0 teilen', null);